<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

<title>pgAdmin Getting Started Guide</title>
</head>

<body>

<h1>pgAdmin Getting Started Guide</h1>

<p>Contributed by: francl with updates from Jean-Michel Poure &amp; Dave Page</p>
<p>This document describes how to install pgAdmin stable release.<br>
  WARNING: Backup your system in case something goes wrong. </p>
<h2>1) Upgrading your Windows system</h2>
<ol>
  <li> Install the MDAC 2.6 RTM (not the Software development kit) from:<br>
    <a href="http://www.microsoft.com/data/download_260rtm.htm">http://www.microsoft.com/data/download_260rtm.htm</a></li>
  <li>If you are not running Access2K, jump to step 3.<br>
    If you are running Access2K, download and install JetSP3 from:<br>
    <a href="http://www.microsoft.com/data/download_Jet4SP3.htm">http://www.microsoft.com/data/download_Jet4SP3.htm</a></li>
  <li>Download and install the &quot;Windows Installer&quot; file &quot;InstMsi.exe&quot;
    ver1.1 from microsoft:<br>
    <a href="http://www.microsoft.com/downloads/search.asp">http://www.microsoft.com/downloads/search.asp</a>&nbsp;
  </li>
  <li>Get the PostgreSQL ODBC driver: the recommended versions are now in:<br>
    <a href="ftp.postgresql.org/pub/odbc/versions/full">ftp.postgresql.org/pub/odbc/versions/full</a>
    or <a href="ftp.postgresql.org/pub/odbc/versions/msi">ftp.postgresql.org/pub/odbc/versions/msi</a>.
  </li>
</ol>
<h2>2) Installing pgAdmin </h2>
<h3>a) Getting pgAdmin latest stable release</h3>
<ol>
  <li>Go to <a href="http://www.greatbridge.org/project/pgadmin/download/download.php">http://www.greatbridge.org/project/pgadmin/download/download.php</a><br>
    and download the last stable release installer.</li>
  <li>Unzip the latest &quot;pgAdmin&quot; software and you will get a file &quot;pgAdmin.msi&quot;.<br>
    You should be able to double click this to install it.</li>
</ol>
<h3>b) Configuring PostgreSQL Server to accept TCP/IP connections</h3>
<ol>
  <li>Make sure you have the postmaster running on your PostgreSQL server in order
    to connect. Either ensure that the postmaster process was started with the
    -i option, or, new PostgreSQL's have a data/postgresql.conf file. Open the
    file in you preferred editor and uncomment #tcpip_socket=false and write tcpip_socket=true.
    You will need to restart PostgreSQL for this change to take effect.</li>
  <li>You may have to add a line to your &quot;data/pg_hba.conf&quot; file on
    your server to allow your windows PC to connect to the PostgreSQL Database.
    See below for sample line I added. Just replace 192.168.1.1 with your windows
    PC's IP address. You can allow access from a group of hosts or subnet by adjusting
    the subnet mask as appropriate.<br>
  </li>
  <blockquote>
    <p>host 192.168.1.1 255.255.255.0 password</p>
  </blockquote>
  <li>Create a PostgreSQL user with CREATEDB and CREATEUSER privileges.</li>
</ol>
<h3>c) Configuring ODBC connection </h3>
<ol>
  <li>Once all this is down you can start pgAdmin and add a new datasource from
    the Login Prompt, or use the ODBC data source administrator in the Control
    Panel.</li>
  <li>Once you are running pgAdmin, go into Utilities and try to run &quot;psql&quot;.
    If it doesn't run, make sure the full path name to the &quot;psql.exe&quot;
    is specified (should be something like &quot;C:\Program Files\pgAdmin\psql.exe&quot;)</li>
</ol>

<h2>3) Getting the latest CVS updates</h2>
<ol>
  <li>Go to <a href="http://www.greatbridge.org/project/pgadmin/viewcvs/binaries/">http://www.greatbridge.org/project/pgadmin/viewcvs/binaries/</a> 
    and download the latest readme.html file which explains how to get and install 
    the latest pgAdmin updates from CVS.</li>
</ol>
</body>

</html>
